package com.wing.cabinet.dao;

import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.wing.cabinet.model.entity.CellSingleInventoryProduct;
import com.wing.cabinet.model.response.CellSingleInventoryProductExportVO;
import com.wing.cabinet.model.response.CellSingleInventoryProductVO;
import com.wing.cabinet.model.response.CelllnventoryAlarmExportVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

/**
 * 售刀柜sku库存(某个柜子)-Dao
 *
 * @author
 */
@Mapper
public interface CellSingleInventoryProductDao extends BaseMapper<CellSingleInventoryProduct> {

    /**
     * 列表-app
     *
     * @param params
     *
     * @return
     */
    List<CellSingleInventoryProductVO> list4app(@Param("params") Map<String, Object> params);

    /**
     * 分页列表-app
     *
     * @param page
     * @param params
     *
     * @return
     */
    List<CellSingleInventoryProductVO> list4app(@Param("page") Page<CellSingleInventoryProductVO> page, @Param("params") Map<String, Object> params);
    List<CellSingleInventoryProductVO> list4Alarm(@Param("page") Page<CellSingleInventoryProductVO> page, @Param("params") Map<String, Object> params);
    List<CelllnventoryAlarmExportVO> getCelllnventoryAlarmExport(@Param("params") Map<String, Object> params);
    List<CellSingleInventoryProductVO> list4Alarm(@Param("params") Map<String, Object> params);

    Integer count4Alarm(@Param("params") Map<String, Object> params);

    List<CellSingleInventoryProductVO> listSku4app(@Param("page") Page<CellSingleInventoryProductVO> page, @Param("params") Map<String, Object> params);

    List<CellSingleInventoryProductVO> listAlarm4app(@Param("page") Page<CellSingleInventoryProductVO> page, @Param("params") Map<String, Object> params);

    List<CellSingleInventoryProductVO> list4ChildCab(@Param("page") Page<CellSingleInventoryProductVO> page, @Param("params") Map<String, Object> params);

    List<CellSingleInventoryProductVO> list4MainCab(@Param("page") Page<CellSingleInventoryProductVO> page, @Param("params") Map<String, Object> params);

    List<CellSingleInventoryProductVO> listAlarm4app(@Param("params") Map<String, Object> params);

    List<CellSingleInventoryProductVO> getCabSkuInventory(@Param("params") Map<String, Object> params);

    /**
     * 详情-app
     *
     * @param id
     *
     * @return
     */
    CellSingleInventoryProductVO get4appById(Long id);

    List<CellSingleInventoryProductVO> pageListPressCabinet(@Param("page") Page<CellSingleInventoryProductVO> page, @Param("params") Map<String, Object> params);

    List<CellSingleInventoryProductVO> exportPressCabinet();

    List<CellSingleInventoryProductVO> getInventoryBySkuCodeAndBelongCabinet(@Param("page") Page<CellSingleInventoryProductVO> page,@Param("params") Map<String, Object> params);

    List<CellSingleInventoryProductVO> getAlarmInformation();

    Integer countSkuByMainCabCode(String mainCabCode);

    List<CellSingleInventoryProductExportVO> exportList(@Param("params")Map queryParam);

    List<CellSingleInventoryProductExportVO> exportChild(@Param("params")Map queryParam);
}
